Dataset statistics
| Number of variables | 52 |
|---|---|
| Number of observations | 16947 |
| Missing cells | 18150 |
| Missing cells (%) | 2.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.6 MiB |
| Average record size in memory | 223.0 B |
Variable types
| CAT | 32 |
|---|---|
| NUM | 9 |
| DATE | 6 |
| BOOL | 5 |
Submitted_for_Approval has constant value "16947" | Constant |
Last_Activity has constant value "16947" | Constant |
ASP_(converted)_Currency has constant value "16947" | Constant |
Actual_Delivery_Date has constant value "16947" | Constant |
Prod_Category_A has constant value "16947" | Constant |
Territory has a high cardinality: 76 distinct values | High cardinality |
Billing_Country has a high cardinality: 80 distinct values | High cardinality |
Account_Name has a high cardinality: 1635 distinct values | High cardinality |
Opportunity_Name has a high cardinality: 9841 distinct values | High cardinality |
Opportunity_Owner has a high cardinality: 53 distinct values | High cardinality |
Price has a high cardinality: 53 distinct values | High cardinality |
Last_Modified_By has a high cardinality: 55 distinct values | High cardinality |
Product_Family has a high cardinality: 227 distinct values | High cardinality |
Product_Name has a high cardinality: 456 distinct values | High cardinality |
Month has a high cardinality: 53 distinct values | High cardinality |
Delivery_Year is highly correlated with Sales_Contract_No | High correlation |
Sales_Contract_No is highly correlated with Delivery_Year | High correlation |
Territory is highly correlated with Region | High correlation |
Region is highly correlated with Territory and 3 other fields | High correlation |
Billing_Country is highly correlated with Region | High correlation |
Account_Owner is highly correlated with Region | High correlation |
Opportunity_Owner is highly correlated with Region | High correlation |
Delivery_Quarter is highly correlated with Month | High correlation |
Month is highly correlated with Delivery_Quarter | High correlation |
Total_Amount_Currency is highly correlated with ASP_Currency and 1 other fields | High correlation |
ASP_Currency is highly correlated with Total_Amount_Currency and 1 other fields | High correlation |
Total_Taxable_Amount_Currency is highly correlated with ASP_Currency and 1 other fields | High correlation |
Sales_Contract_No has 6973 (41.1%) missing values | Missing |
Quote_Expiry_Date has 4625 (27.3%) missing values | Missing |
ASP has 3209 (18.9%) missing values | Missing |
ASP_(converted) has 3209 (18.9%) missing values | Missing |
ASP_(converted) is highly skewed (γ1 = 80.47407411) | Skewed |
Total_Amount is highly skewed (γ1 = 42.00442155) | Skewed |
Total_Taxable_Amount is highly skewed (γ1 = 33.59918963) | Skewed |
ID has unique values | Unique |
ASP has 301 (1.8%) zeros | Zeros |
ASP_(converted) has 300 (1.8%) zeros | Zeros |
TRF has 11971 (70.6%) zeros | Zeros |
Total_Taxable_Amount has 997 (5.9%) zeros | Zeros |
Reproduction
| Analysis started | 2020-10-24 14:33:06.555382 |
|---|---|
| Analysis finished | 2020-10-24 14:33:39.544073 |
| Duration | 32.99 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 16947 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17666.65044 |
|---|---|
| Minimum | 4854 |
| Maximum | 28773 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 132.4 KiB |
Quantile statistics
| Minimum | 4854 |
|---|---|
| 5-th percentile | 6095.3 |
| Q1 | 11953 |
| median | 18114 |
| Q3 | 23845.5 |
| 95-th percentile | 27687.4 |
| Maximum | 28773 |
| Range | 23919 |
| Interquartile range (IQR) | 11892.5 |
Descriptive statistics
| Standard deviation | 6940.859372 |
|---|---|
| Coefficient of variation (CV) | 0.3928791933 |
| Kurtosis | -1.172033787 |
| Mean | 17666.65044 |
| Median Absolute Deviation (MAD) | 5914 |
| Skewness | -0.1785736993 |
| Sum | 299396725 |
| Variance | 48175528.83 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6141 | 1 | < 0.1% | |
| 27384 | 1 | < 0.1% | |
| 21263 | 1 | < 0.1% | |
| 19212 | 1 | < 0.1% | |
| 25353 | 1 | < 0.1% | |
| 27400 | 1 | < 0.1% | |
| 4871 | 1 | < 0.1% | |
| 13059 | 1 | < 0.1% | |
| 15106 | 1 | < 0.1% | |
| 8961 | 1 | < 0.1% | |
| Other values (16937) | 16937 | 99.9% |
| Value | Count | Frequency (%) | |
| 4854 | 1 | < 0.1% | |
| 4856 | 1 | < 0.1% | |
| 4858 | 1 | < 0.1% | |
| 4859 | 1 | < 0.1% | |
| 4860 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 28773 | 1 | < 0.1% | |
| 28772 | 1 | < 0.1% | |
| 28771 | 1 | < 0.1% | |
| 28770 | 1 | < 0.1% | |
| 28769 | 1 | < 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.7 KiB |
| Japan | |
|---|---|
| EMEA | |
| Americas | |
| APAC | |
| Middle East | 184 |
| Value | Count | Frequency (%) | |
| Japan | 4892 | 28.9% | |
| EMEA | 4664 | 27.5% | |
| Americas | 3945 | 23.3% | |
| APAC | 3262 | 19.2% | |
| Middle East | 184 | 1.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 11 |
|---|---|
| Median length | 5 |
| Mean length | 5.295804567 |
| Min length | 4 |
| Distinct | 76 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.6 KiB |
| None | |
|---|---|
| Germany | |
| NW America | |
| Australia | |
| India | |
| Other values (71) |
| Value | Count | Frequency (%) | |
| None | 4999 | 29.5% | |
| Germany | 1682 | 9.9% | |
| NW America | 1568 | 9.3% | |
| Australia | 1208 | 7.1% | |
| India | 809 | 4.8% | |
| NE America | 760 | 4.5% | |
| Japan | 681 | 4.0% | |
| Netherlands | 533 | 3.1% | |
| SE America | 493 | 2.9% | |
| France | 449 | 2.6% | |
| Other values (66) | 3765 | 22.2% |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 20 |
|---|---|
| Median length | 7 |
| Mean length | 7.018646368 |
| Min length | 3 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 13693 | 80.8% | |
| 0 | 3254 | 19.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 9890 | 58.4% | |
| 0 | 7057 | 41.6% |
Bureaucratic_Code_0_Approval
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 8889 | 52.5% | |
| 1 | 8058 | 47.5% |
Bureaucratic_Code_0_Approved
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 11543 | 68.1% | |
| 1 | 5404 | 31.9% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 KiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 16947 | 100.0% |
Bureaucratic_Code
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.9 KiB |
| Bureaucratic_Code_4 | |
|---|---|
| Bureaucratic_Code_5 | |
| Bureaucratic_Code_1 | 261 |
| Bureaucratic_Code_2 | 242 |
| Bureaucratic_Code_0 | 51 |
| Other values (2) | 3 |
| Value | Count | Frequency (%) | |
| Bureaucratic_Code_4 | 12587 | 74.3% | |
| Bureaucratic_Code_5 | 3803 | 22.4% | |
| Bureaucratic_Code_1 | 261 | 1.5% | |
| Bureaucratic_Code_2 | 242 | 1.4% | |
| Bureaucratic_Code_0 | 51 | 0.3% | |
| Bureaucratic_Code_3 | 2 | < 0.1% | |
| Bureaucratic_Code_6 | 1 | < 0.1% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
| Distinct | 809 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.4 KiB |
| Minimum | 2013-07-27 00:00:00 |
|---|---|
| Maximum | 2018-12-21 00:00:00 |
Source
Categorical
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.3 KiB |
| None | |
|---|---|
| Source_7 | |
| Source_9 | |
| Source_11 | |
| Source_13 | 786 |
| Other values (9) | 819 |
| Value | Count | Frequency (%) | |
| None | 9497 | 56.0% | |
| Source_7 | 2965 | 17.5% | |
| Source_9 | 1459 | 8.6% | |
| Source_11 | 1421 | 8.4% | |
| Source_13 | 786 | 4.6% | |
| Source_3 | 418 | 2.5% | |
| Source_1 | 137 | 0.8% | |
| Source_10 | 106 | 0.6% | |
| Source_2 | 86 | 0.5% | |
| Source_4 | 43 | 0.3% | |
| Other values (4) | 29 | 0.2% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 9 |
|---|---|
| Median length | 4 |
| Mean length | 5.895025668 |
| Min length | 4 |
| Distinct | 80 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.7 KiB |
| Japan | |
|---|---|
| United States | |
| Germany | |
| Australia | |
| India | |
| Other values (75) |
| Value | Count | Frequency (%) | |
| Japan | 4879 | 28.8% | |
| United States | 3802 | 22.4% | |
| Germany | 1979 | 11.7% | |
| Australia | 1169 | 6.9% | |
| India | 672 | 4.0% | |
| Netherlands | 563 | 3.3% | |
| Singapore | 432 | 2.5% | |
| France | 396 | 2.3% | |
| Spain | 317 | 1.9% | |
| Italy | 295 | 1.7% | |
| Other values (70) | 2443 | 14.4% |
Unique
| Unique | 15 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 42 |
|---|---|
| Median length | 7 |
| Mean length | 8.187289786 |
| Min length | 4 |
| Distinct | 1635 |
|---|---|
| Distinct (%) | 9.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 125.9 KiB |
| Account_Name_1888 | |
|---|---|
| Account_Name_1836 | 886 |
| Account_Name_25 | 752 |
| Account_Name_1991 | 586 |
| Account_Name_1642 | 397 |
| Other values (1630) |
| Value | Count | Frequency (%) | |
| Account_Name_1888 | 2124 | 12.5% | |
| Account_Name_1836 | 886 | 5.2% | |
| Account_Name_25 | 752 | 4.4% | |
| Account_Name_1991 | 586 | 3.5% | |
| Account_Name_1642 | 397 | 2.3% | |
| Account_Name_1508 | 355 | 2.1% | |
| Account_Name_1440 | 317 | 1.9% | |
| Account_Name_533 | 283 | 1.7% | |
| Account_Name_263 | 249 | 1.5% | |
| Account_Name_660 | 231 | 1.4% | |
| Other values (1625) | 10767 | 63.5% |
Unique
| Unique | 637 ? |
|---|---|
| Unique (%) | 3.8% |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.51560748 |
| Min length | 14 |
| Distinct | 9841 |
|---|---|
| Distinct (%) | 58.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 430.0 KiB |
| Opportunity_Name_9795 | 36 |
|---|---|
| Opportunity_Name_5036 | 36 |
| Opportunity_Name_12179 | 26 |
| Opportunity_Name_11461 | 26 |
| Opportunity_Name_6835 | 24 |
| Other values (9836) |
| Value | Count | Frequency (%) | |
| Opportunity_Name_9795 | 36 | 0.2% | |
| Opportunity_Name_5036 | 36 | 0.2% | |
| Opportunity_Name_12179 | 26 | 0.2% | |
| Opportunity_Name_11461 | 26 | 0.2% | |
| Opportunity_Name_6835 | 24 | 0.1% | |
| Opportunity_Name_1661 | 18 | 0.1% | |
| Opportunity_Name_9628 | 16 | 0.1% | |
| Opportunity_Name_10946 | 16 | 0.1% | |
| Opportunity_Name_10945 | 16 | 0.1% | |
| Opportunity_Name_10944 | 16 | 0.1% | |
| Other values (9831) | 16717 | 98.6% |
Unique
| Unique | 6921 ? |
|---|---|
| Unique (%) | 40.8% |
Length
| Max length | 22 |
|---|---|
| Median length | 21 |
| Mean length | 21.15271139 |
| Min length | 18 |
Opportunity_ID
Real number (ℝ≥0)
| Distinct | 9841 |
|---|---|
| Distinct (%) | 58.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5335.940225 |
|---|---|
| Minimum | 0 |
| Maximum | 12803 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 132.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 435.3 |
| Q1 | 2448.5 |
| median | 5306 |
| Q3 | 7698 |
| 95-th percentile | 11203.5 |
| Maximum | 12803 |
| Range | 12803 |
| Interquartile range (IQR) | 5249.5 |
Descriptive statistics
| Standard deviation | 3324.723809 |
|---|---|
| Coefficient of variation (CV) | 0.623081157 |
| Kurtosis | -0.7150386945 |
| Mean | 5335.940225 |
| Median Absolute Deviation (MAD) | 2623 |
| Skewness | 0.2852975553 |
| Sum | 90428179 |
| Variance | 11053788.41 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) | |
| 12460 | 36 | 0.2% | |
| 2008 | 36 | 0.2% | |
| 5123 | 26 | 0.2% | |
| 6606 | 26 | 0.2% | |
| 2911 | 24 | 0.1% | |
| 767 | 18 | 0.1% | |
| 6654 | 16 | 0.1% | |
| 8698 | 16 | 0.1% | |
| 6653 | 16 | 0.1% | |
| 7568 | 16 | 0.1% | |
| Other values (9831) | 16717 | 98.6% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 12803 | 1 | < 0.1% | |
| 12802 | 1 | < 0.1% | |
| 12801 | 3 | < 0.1% | |
| 12800 | 2 | < 0.1% | |
| 12799 | 1 | < 0.1% |
| Distinct | 5266 |
|---|---|
| Distinct (%) | 52.8% |
| Missing | 6973 |
| Missing (%) | 41.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2725.414979 |
|---|---|
| Minimum | 0 |
| Maximum | 6517 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 132.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 240.65 |
| Q1 | 1396.5 |
| median | 2801.5 |
| Q3 | 4009 |
| 95-th percentile | 5203.35 |
| Maximum | 6517 |
| Range | 6517 |
| Interquartile range (IQR) | 2612.5 |
Descriptive statistics
| Standard deviation | 1569.252469 |
|---|---|
| Coefficient of variation (CV) | 0.5757847818 |
| Kurtosis | -1.132015109 |
| Mean | 2725.414979 |
| Median Absolute Deviation (MAD) | 1285 |
| Skewness | -0.0416636759 |
| Sum | 27183289 |
| Variance | 2462553.311 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 108 | 36 | 0.2% | |
| 479 | 36 | 0.2% | |
| 2575 | 18 | 0.1% | |
| 3980 | 16 | 0.1% | |
| 3876 | 16 | 0.1% | |
| 3877 | 16 | 0.1% | |
| 3878 | 16 | 0.1% | |
| 3123 | 16 | 0.1% | |
| 5583 | 16 | 0.1% | |
| 4526 | 14 | 0.1% | |
| Other values (5256) | 9774 | 57.7% | |
| (Missing) | 6973 | 41.1% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 5 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6517 | 1 | < 0.1% | |
| 6516 | 1 | < 0.1% | |
| 6515 | 2 | < 0.1% | |
| 5593 | 3 | < 0.1% | |
| 5590 | 2 | < 0.1% |
| Distinct | 48 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.2 KiB |
| Person_Name_50 | |
|---|---|
| Person_Name_13 | |
| Person_Name_8 | |
| Person_Name_43 | |
| Person_Name_18 | |
| Other values (43) |
| Value | Count | Frequency (%) | |
| Person_Name_50 | 3730 | 22.0% | |
| Person_Name_13 | 1328 | 7.8% | |
| Person_Name_8 | 1286 | 7.6% | |
| Person_Name_43 | 1241 | 7.3% | |
| Person_Name_18 | 1093 | 6.4% | |
| Person_Name_3 | 875 | 5.2% | |
| Person_Name_32 | 682 | 4.0% | |
| Person_Name_4 | 664 | 3.9% | |
| Person_Name_65 | 631 | 3.7% | |
| Person_Name_64 | 577 | 3.4% | |
| Other values (38) | 4840 | 28.6% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 13.80090872 |
| Min length | 13 |
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.5 KiB |
| Person_Name_50 | |
|---|---|
| Person_Name_8 | |
| Person_Name_13 | |
| Person_Name_18 | |
| Person_Name_43 | 838 |
| Other values (48) |
| Value | Count | Frequency (%) | |
| Person_Name_50 | 3781 | 22.3% | |
| Person_Name_8 | 1422 | 8.4% | |
| Person_Name_13 | 1254 | 7.4% | |
| Person_Name_18 | 982 | 5.8% | |
| Person_Name_43 | 838 | 4.9% | |
| Person_Name_3 | 832 | 4.9% | |
| Person_Name_4 | 687 | 4.1% | |
| Person_Name_32 | 686 | 4.0% | |
| Person_Name_19 | 615 | 3.6% | |
| Person_Name_64 | 516 | 3.0% | |
| Other values (43) | 5334 | 31.5% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 13.8094648 |
| Min length | 13 |
Account_Type
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.9 KiB |
| Account_Type_2 | |
|---|---|
| Account_Type_0 | |
| Account_Type_5 | |
| Account_Type_1 | 165 |
| None | 112 |
| Other values (2) | 27 |
| Value | Count | Frequency (%) | |
| Account_Type_2 | 8832 | 52.1% | |
| Account_Type_0 | 5868 | 34.6% | |
| Account_Type_5 | 1943 | 11.5% | |
| Account_Type_1 | 165 | 1.0% | |
| None | 112 | 0.7% | |
| Account_Type_6 | 17 | 0.1% | |
| Account_Type_4 | 10 | 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 13.93391161 |
| Min length | 4 |
Opportunity_Type
Categorical
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.4 KiB |
| Opportunity_Type_1 | |
|---|---|
| Opportunity_Type_7 | |
| Opportunity_Type_19 | |
| Opportunity_Type_8 | |
| Opportunity_Type_12 | 279 |
| Other values (20) |
| Value | Count | Frequency (%) | |
| Opportunity_Type_1 | 6819 | 40.2% | |
| Opportunity_Type_7 | 5763 | 34.0% | |
| Opportunity_Type_19 | 1900 | 11.2% | |
| Opportunity_Type_8 | 1458 | 8.6% | |
| Opportunity_Type_12 | 279 | 1.6% | |
| Opportunity_Type_3 | 275 | 1.6% | |
| Opportunity_Type_20 | 175 | 1.0% | |
| Opportunity_Type_2 | 70 | 0.4% | |
| Opportunity_Type_4 | 51 | 0.3% | |
| Opportunity_Type_10 | 34 | 0.2% | |
| Other values (15) | 123 | 0.7% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 19 |
|---|---|
| Median length | 18 |
| Mean length | 18.14539447 |
| Min length | 18 |
Quote_Type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.6 KiB |
| Non Binding | |
|---|---|
| Binding | 170 |
| Value | Count | Frequency (%) | |
| Non Binding | 16777 | 99.0% | |
| Binding | 170 | 1.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.9598749 |
| Min length | 7 |
Delivery_Terms
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.9 KiB |
| Delivery_Terms_4 | |
|---|---|
| Delivery_Terms_2 | |
| Delivery_Terms_1 | |
| Delivery_Terms_6 | |
| Delivery_Terms_5 | 636 |
| Other values (4) | 249 |
| Value | Count | Frequency (%) | |
| Delivery_Terms_4 | 7712 | 45.5% | |
| Delivery_Terms_2 | 4633 | 27.3% | |
| Delivery_Terms_1 | 2936 | 17.3% | |
| Delivery_Terms_6 | 781 | 4.6% | |
| Delivery_Terms_5 | 636 | 3.8% | |
| Delivery_Terms_8 | 164 | 1.0% | |
| Delivery_Terms_3 | 41 | 0.2% | |
| Delivery_Terms_7 | 38 | 0.2% | |
| Delivery_Terms_0 | 6 | < 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
| Distinct | 1096 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.4 KiB |
| Minimum | 2013-11-05 00:00:00 |
|---|---|
| Maximum | 2018-12-29 00:00:00 |
Brand
Categorical
| Distinct | 26 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.0 KiB |
| None | |
|---|---|
| Other | 607 |
| Brand_9 | 140 |
| Brand_5 | 48 |
| Brand_24 | 38 |
| Other values (21) | 203 |
| Value | Count | Frequency (%) | |
| None | 15911 | 93.9% | |
| Other | 607 | 3.6% | |
| Brand_9 | 140 | 0.8% | |
| Brand_5 | 48 | 0.3% | |
| Brand_24 | 38 | 0.2% | |
| Brand_11 | 34 | 0.2% | |
| Brand_25 | 24 | 0.1% | |
| Brand_10 | 22 | 0.1% | |
| Brand_22 | 20 | 0.1% | |
| Brand_7 | 17 | 0.1% | |
| Other values (16) | 86 | 0.5% |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 4.12409276 |
| Min length | 4 |
Product_Type
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.9 KiB |
| None | |
|---|---|
| Other | 515 |
| Product_Type_3 | 179 |
| Product_Type_1 | 142 |
| Product_Type_0 | 94 |
| Other values (2) | 82 |
| Value | Count | Frequency (%) | |
| None | 15935 | 94.0% | |
| Other | 515 | 3.0% | |
| Product_Type_3 | 179 | 1.1% | |
| Product_Type_1 | 142 | 0.8% | |
| Product_Type_0 | 94 | 0.6% | |
| Product_Type_4 | 73 | 0.4% | |
| Product_Type_2 | 9 | 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 14 |
|---|---|
| Median length | 4 |
| Mean length | 4.323656104 |
| Min length | 4 |
Size
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.9 KiB |
| None | |
|---|---|
| Other | 394 |
| Size_3 | 356 |
| Size_4 | 196 |
| Size_1 | 25 |
| Other values (2) | 9 |
| Value | Count | Frequency (%) | |
| None | 15967 | 94.2% | |
| Other | 394 | 2.3% | |
| Size_3 | 356 | 2.1% | |
| Size_4 | 196 | 1.2% | |
| Size_1 | 25 | 0.1% | |
| Size_0 | 7 | < 0.1% | |
| Size_2 | 2 | < 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.092405736 |
| Min length | 4 |
Product_Category_B
Categorical
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.0 KiB |
| None | |
|---|---|
| Other | 523 |
| Product_Category_B_2 | 59 |
| Product_Category_B_12 | 51 |
| Product_Category_B_7 | 47 |
| Other values (23) | 339 |
| Value | Count | Frequency (%) | |
| None | 15928 | 94.0% | |
| Other | 523 | 3.1% | |
| Product_Category_B_2 | 59 | 0.3% | |
| Product_Category_B_12 | 51 | 0.3% | |
| Product_Category_B_7 | 47 | 0.3% | |
| Product_Category_B_4 | 37 | 0.2% | |
| Product_Category_B_5 | 36 | 0.2% | |
| Product_Category_B_17 | 27 | 0.2% | |
| Product_Category_B_1 | 24 | 0.1% | |
| Product_Category_B_3 | 23 | 0.1% | |
| Other values (18) | 192 | 1.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 21 |
|---|---|
| Median length | 4 |
| Mean length | 4.512008025 |
| Min length | 4 |
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.4 KiB |
| None | |
|---|---|
| Other | 609 |
| 0.24 | 27 |
| 0.41 | 22 |
| 0.28 | 20 |
| Other values (48) | 287 |
| Value | Count | Frequency (%) | |
| None | 15982 | 94.3% | |
| Other | 609 | 3.6% | |
| 0.24 | 27 | 0.2% | |
| 0.41 | 22 | 0.1% | |
| 0.28 | 20 | 0.1% | |
| 0.27 | 18 | 0.1% | |
| 0.29 | 17 | 0.1% | |
| 0.32 | 15 | 0.1% | |
| 0.38 | 14 | 0.1% | |
| 0.35 | 14 | 0.1% | |
| Other values (43) | 209 | 1.2% |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.039062961 |
| Min length | 3 |
Currency
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.7 KiB |
| None | |
|---|---|
| EUR | 475 |
| USD | 420 |
| Value | Count | Frequency (%) | |
| None | 16052 | 94.7% | |
| EUR | 475 | 2.8% | |
| USD | 420 | 2.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.947188293 |
| Min length | 3 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.4 KiB |
| NaT |
|---|
| Value | Count | Frequency (%) | |
| NaT | 16947 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 1002 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 4625 |
| Missing (%) | 27.3% |
| Memory size | 132.4 KiB |
| Minimum | 2014-09-30 00:00:00 |
|---|---|
| Maximum | 2019-06-30 00:00:00 |
| Distinct | 650 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.4 KiB |
| Minimum | 2015-03-12 00:00:00 |
|---|---|
| Maximum | 2018-12-29 00:00:00 |
| Distinct | 55 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.5 KiB |
| Person_Name_47 | |
|---|---|
| Person_Name_50 | |
| Person_Name_43 | 587 |
| Person_Name_13 | 578 |
| Person_Name_8 | 511 |
| Other values (50) |
| Value | Count | Frequency (%) | |
| Person_Name_47 | 8515 | 50.2% | |
| Person_Name_50 | 1210 | 7.1% | |
| Person_Name_43 | 587 | 3.5% | |
| Person_Name_13 | 578 | 3.4% | |
| Person_Name_8 | 511 | 3.0% | |
| Person_Name_18 | 438 | 2.6% | |
| Person_Name_33 | 429 | 2.5% | |
| Person_Name_19 | 395 | 2.3% | |
| Person_Name_3 | 395 | 2.3% | |
| Person_Name_4 | 315 | 1.9% | |
| Other values (45) | 3574 | 21.1% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 13.89809406 |
| Min length | 13 |
| Distinct | 227 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.9 KiB |
| Product_Family_77 | |
|---|---|
| Product_Family_133 | |
| Product_Family_132 | 763 |
| Product_Family_212 | 636 |
| Product_Family_100 | 619 |
| Other values (222) |
| Value | Count | Frequency (%) | |
| Product_Family_77 | 1345 | 7.9% | |
| Product_Family_133 | 1249 | 7.4% | |
| Product_Family_132 | 763 | 4.5% | |
| Product_Family_212 | 636 | 3.8% | |
| Product_Family_100 | 619 | 3.7% | |
| Product_Family_85 | 596 | 3.5% | |
| Product_Family_115 | 540 | 3.2% | |
| Product_Family_226 | 524 | 3.1% | |
| Product_Family_109 | 499 | 2.9% | |
| Product_Family_208 | 478 | 2.8% | |
| Other values (217) | 9698 | 57.2% |
Unique
| Unique | 29 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 17.6441258 |
| Min length | 16 |
| Distinct | 456 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.7 KiB |
| Product_Name_100 | 976 |
|---|---|
| Product_Name_226 | 836 |
| Product_Name_231 | 579 |
| Product_Name_491 | 524 |
| Product_Name_4 | 474 |
| Other values (451) |
| Value | Count | Frequency (%) | |
| Product_Name_100 | 976 | 5.8% | |
| Product_Name_226 | 836 | 4.9% | |
| Product_Name_231 | 579 | 3.4% | |
| Product_Name_491 | 524 | 3.1% | |
| Product_Name_4 | 474 | 2.8% | |
| Product_Name_192 | 442 | 2.6% | |
| Product_Name_111 | 388 | 2.3% | |
| Product_Name_132 | 383 | 2.3% | |
| Product_Name_495 | 350 | 2.1% | |
| Product_Name_29 | 345 | 2.0% | |
| Other values (446) | 11650 | 68.7% |
Unique
| Unique | 84 ? |
|---|---|
| Unique (%) | 0.5% |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 15.74609075 |
| Min length | 14 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.7 KiB |
| USD | |
|---|---|
| JPY | |
| EUR | |
| AUD | 556 |
| GBP | 5 |
| Value | Count | Frequency (%) | |
| USD | 7361 | 43.4% | |
| JPY | 4522 | 26.7% | |
| EUR | 4503 | 26.6% | |
| AUD | 556 | 3.3% | |
| GBP | 5 | < 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 301 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 3209 |
| Missing (%) | 18.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.012128279 |
|---|---|
| Minimum | 0 |
| Maximum | 80 |
| Zeros | 301 |
| Zeros (%) | 1.8% |
| Memory size | 132.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.25 |
| Q1 | 0.36 |
| median | 0.4 |
| Q3 | 0.505 |
| 95-th percentile | 59 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range (IQR) | 0.145 |
Descriptive statistics
| Standard deviation | 18.85835901 |
|---|---|
| Coefficient of variation (CV) | 2.689391617 |
| Kurtosis | 5.261237009 |
| Mean | 7.012128279 |
| Median Absolute Deviation (MAD) | 0.06 |
| Skewness | 2.623799882 |
| Sum | 96332.6183 |
| Variance | 355.6377046 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0.38 | 801 | 4.7% | |
| 0.4 | 712 | 4.2% | |
| 0.36 | 564 | 3.3% | |
| 0.42 | 510 | 3.0% | |
| 0.39 | 465 | 2.7% | |
| 0.37 | 365 | 2.2% | |
| 0 | 301 | 1.8% | |
| 0.35 | 295 | 1.7% | |
| 0.34 | 270 | 1.6% | |
| 0.365 | 269 | 1.6% | |
| Other values (291) | 9186 | 54.2% | |
| (Missing) | 3209 | 18.9% |
| Value | Count | Frequency (%) | |
| 0 | 301 | 1.8% | |
| 1e-05 | 1 | < 0.1% | |
| 0.15 | 53 | 0.3% | |
| 0.16 | 8 | < 0.1% | |
| 0.17 | 114 | 0.7% |
| Value | Count | Frequency (%) | |
| 80 | 14 | 0.1% | |
| 78 | 86 | 0.5% | |
| 77 | 12 | 0.1% | |
| 76 | 6 | < 0.1% | |
| 75 | 99 | 0.6% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.6 KiB |
| USD |
|---|
| Value | Count | Frequency (%) | |
| USD | 16947 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 441 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 3209 |
| Missing (%) | 18.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4325537043 |
|---|---|
| Minimum | 0 |
| Maximum | 67 |
| Zeros | 300 |
| Zeros (%) | 1.8% |
| Memory size | 132.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.27 |
| Q1 | 0.37326 |
| median | 0.41285 |
| Q3 | 0.47649 |
| 95-th percentile | 0.63 |
| Maximum | 67 |
| Range | 67 |
| Interquartile range (IQR) | 0.10323 |
Descriptive statistics
| Standard deviation | 0.7586587831 |
|---|---|
| Coefficient of variation (CV) | 1.753906568 |
| Kurtosis | 6675.953735 |
| Mean | 0.4325537043 |
| Median Absolute Deviation (MAD) | 0.0509 |
| Skewness | 80.47407411 |
| Sum | 5942.42279 |
| Variance | 0.5755631491 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0.38 | 570 | 3.4% | |
| 0.4 | 497 | 2.9% | |
| 0.36 | 326 | 1.9% | |
| 0.39 | 325 | 1.9% | |
| 0 | 300 | 1.8% | |
| 0.42 | 294 | 1.7% | |
| 0.40719 | 234 | 1.4% | |
| 0.42982 | 230 | 1.4% | |
| 0.47506 | 216 | 1.3% | |
| 0.45244 | 214 | 1.3% | |
| Other values (431) | 10532 | 62.1% | |
| (Missing) | 3209 | 18.9% |
| Value | Count | Frequency (%) | |
| 0 | 300 | 1.8% | |
| 1e-05 | 1 | < 0.1% | |
| 0.00378 | 1 | < 0.1% | |
| 0.15 | 53 | 0.3% | |
| 0.16 | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 67 | 1 | < 0.1% | |
| 57.68578 | 1 | < 0.1% | |
| 1.7 | 1 | < 0.1% | |
| 1.6 | 6 | < 0.1% | |
| 1 | 2 | < 0.1% |
| Distinct | 986 |
|---|---|
| Distinct (%) | 5.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.4 KiB |
| Minimum | 2016-01-01 00:00:00 |
|---|---|
| Maximum | 2020-09-17 00:00:00 |
| Distinct | 1016 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 75 |
| Missing (%) | 0.4% |
| Memory size | 132.4 KiB |
| Minimum | 2016-01-05 00:00:00 |
|---|---|
| Maximum | 2208-12-31 00:00:00 |
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.4 KiB |
| 2018 - 10 | 666 |
|---|---|
| 2017 - 6 | 643 |
| 2017 - 10 | 638 |
| 2016 - 3 | 628 |
| 2017 - 7 | 625 |
| Other values (48) |
| Value | Count | Frequency (%) | |
| 2018 - 10 | 666 | 3.9% | |
| 2017 - 6 | 643 | 3.8% | |
| 2017 - 10 | 638 | 3.8% | |
| 2016 - 3 | 628 | 3.7% | |
| 2017 - 7 | 625 | 3.7% | |
| 2017 - 5 | 586 | 3.5% | |
| 2018 - 4 | 579 | 3.4% | |
| 2017 - 12 | 574 | 3.4% | |
| 2018 - 6 | 542 | 3.2% | |
| 2018 - 7 | 536 | 3.2% | |
| Other values (43) | 10930 | 64.5% |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.244527055 |
| Min length | 8 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.7 KiB |
| Q2 | |
|---|---|
| Q1 | |
| Q4 | |
| Q3 |
| Value | Count | Frequency (%) | |
| Q2 | 4443 | 26.2% | |
| Q1 | 4317 | 25.5% | |
| Q4 | 4144 | 24.5% | |
| Q3 | 4043 | 23.9% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2017.137428 |
|---|---|
| Minimum | 2016 |
| Maximum | 2020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 33.1 KiB |
Quantile statistics
| Minimum | 2016 |
|---|---|
| 5-th percentile | 2016 |
| Q1 | 2016 |
| median | 2017 |
| Q3 | 2018 |
| 95-th percentile | 2018 |
| Maximum | 2020 |
| Range | 4 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.8296028156 |
|---|---|
| Coefficient of variation (CV) | 0.0004112772902 |
| Kurtosis | -0.9481673267 |
| Mean | 2017.137428 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.03065373257 |
| Sum | 34184428 |
| Variance | 0.6882408316 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2017 | 6318 | 37.3% | |
| 2018 | 5830 | 34.4% | |
| 2016 | 4371 | 25.8% | |
| 2019 | 414 | 2.4% | |
| 2020 | 14 | 0.1% |
| Value | Count | Frequency (%) | |
| 2016 | 4371 | 25.8% | |
| 2017 | 6318 | 37.3% | |
| 2018 | 5830 | 34.4% | |
| 2019 | 414 | 2.4% | |
| 2020 | 14 | 0.1% |
| Value | Count | Frequency (%) | |
| 2020 | 14 | 0.1% | |
| 2019 | 414 | 2.4% | |
| 2018 | 5830 | 34.4% | |
| 2017 | 6318 | 37.3% | |
| 2016 | 4371 | 25.8% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.4 KiB |
| NaT |
|---|
| Value | Count | Frequency (%) | |
| NaT | 16947 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 101 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.338171948 |
|---|---|
| Minimum | 0 |
| Maximum | 500 |
| Zeros | 11971 |
| Zeros (%) | 70.6% |
| Memory size | 132.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 10 |
| Maximum | 500 |
| Range | 500 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 12.16933936 |
|---|---|
| Coefficient of variation (CV) | 5.204638339 |
| Kurtosis | 468.696877 |
| Mean | 2.338171948 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.060823 |
| Sum | 39625 |
| Variance | 148.0928205 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 11971 | 70.6% | |
| 1 | 2192 | 12.9% | |
| 2 | 627 | 3.7% | |
| 3 | 354 | 2.1% | |
| 5 | 297 | 1.8% | |
| 4 | 208 | 1.2% | |
| 10 | 190 | 1.1% | |
| 6 | 131 | 0.8% | |
| 7 | 111 | 0.7% | |
| 20 | 83 | 0.5% | |
| Other values (91) | 783 | 4.6% |
| Value | Count | Frequency (%) | |
| 0 | 11971 | 70.6% | |
| 1 | 2192 | 12.9% | |
| 2 | 627 | 3.7% | |
| 3 | 354 | 2.1% | |
| 4 | 208 | 1.2% |
| Value | Count | Frequency (%) | |
| 500 | 1 | < 0.1% | |
| 429 | 1 | < 0.1% | |
| 400 | 2 | < 0.1% | |
| 270 | 1 | < 0.1% | |
| 250 | 1 | < 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.7 KiB |
| USD | |
|---|---|
| JPY | |
| EUR | |
| AUD | 556 |
| GBP | 5 |
| Value | Count | Frequency (%) | |
| USD | 7361 | 43.4% | |
| JPY | 4522 | 26.7% | |
| EUR | 4503 | 26.6% | |
| AUD | 556 | 3.3% | |
| GBP | 5 | < 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 8872 |
|---|---|
| Distinct (%) | 52.5% |
| Missing | 59 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1993659.215 |
|---|---|
| Minimum | 0 |
| Maximum | 1320000000 |
| Zeros | 52 |
| Zeros (%) | 0.3% |
| Memory size | 132.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2900 |
| Q1 | 26775 |
| median | 107250 |
| Q3 | 460389.825 |
| 95-th percentile | 7010372.365 |
| Maximum | 1320000000 |
| Range | 1320000000 |
| Interquartile range (IQR) | 433614.825 |
Descriptive statistics
| Standard deviation | 18484259.88 |
|---|---|
| Coefficient of variation (CV) | 9.271524312 |
| Kurtosis | 2322.422807 |
| Mean | 1993659.215 |
| Median Absolute Deviation (MAD) | 101050 |
| Skewness | 42.00442155 |
| Sum | 3.366891683e+10 |
| Variance | 3.416678634e+14 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6200 | 513 | 3.0% | |
| 4400 | 461 | 2.7% | |
| 18000 | 353 | 2.1% | |
| 140000 | 272 | 1.6% | |
| 1600 | 204 | 1.2% | |
| 160000 | 132 | 0.8% | |
| 109620 | 100 | 0.6% | |
| 23400 | 80 | 0.5% | |
| 85260 | 75 | 0.4% | |
| 81200 | 75 | 0.4% | |
| Other values (8862) | 14623 | 86.3% |
| Value | Count | Frequency (%) | |
| 0 | 52 | 0.3% | |
| 0.01 | 7 | < 0.1% | |
| 0.02 | 3 | < 0.1% | |
| 0.04 | 1 | < 0.1% | |
| 0.1 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1320000000 | 1 | < 0.1% | |
| 919992410 | 1 | < 0.1% | |
| 760000000 | 1 | < 0.1% | |
| 660005280 | 1 | < 0.1% | |
| 660004620 | 1 | < 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.7 KiB |
| USD | |
|---|---|
| JPY | |
| EUR | |
| AUD | 553 |
| GBP | 4 |
| Value | Count | Frequency (%) | |
| USD | 7347 | 43.4% | |
| JPY | 4525 | 26.7% | |
| EUR | 4518 | 26.7% | |
| AUD | 553 | 3.3% | |
| GBP | 4 | < 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 7096 |
|---|---|
| Distinct (%) | 41.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3224116.789 |
|---|---|
| Minimum | 0 |
| Maximum | 1356338620 |
| Zeros | 997 |
| Zeros (%) | 5.9% |
| Memory size | 132.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 85465.8 |
| median | 376067.25 |
| Q3 | 1037450 |
| 95-th percentile | 12770625 |
| Maximum | 1356338620 |
| Range | 1356338620 |
| Interquartile range (IQR) | 951984.2 |
Descriptive statistics
| Standard deviation | 20303604.73 |
|---|---|
| Coefficient of variation (CV) | 6.297416022 |
| Kurtosis | 1706.197108 |
| Mean | 3224116.789 |
| Median Absolute Deviation (MAD) | 310517.25 |
| Skewness | 33.59918963 |
| Sum | 5.463910723e+10 |
| Variance | 4.122363649e+14 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 997 | 5.9% | |
| 588325 | 72 | 0.4% | |
| 109620 | 68 | 0.4% | |
| 488700 | 66 | 0.4% | |
| 413700 | 60 | 0.4% | |
| 552400 | 60 | 0.4% | |
| 1767640 | 48 | 0.3% | |
| 523100 | 40 | 0.2% | |
| 105840 | 37 | 0.2% | |
| 31053609.6 | 36 | 0.2% | |
| Other values (7086) | 15463 | 91.2% |
| Value | Count | Frequency (%) | |
| 0 | 997 | 5.9% | |
| 0.15 | 1 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 100.1 | 1 | < 0.1% | |
| 101.4 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1356338620 | 1 | < 0.1% | |
| 919992410 | 1 | < 0.1% | |
| 760000000 | 1 | < 0.1% | |
| 660005280 | 1 | < 0.1% | |
| 660004620 | 1 | < 0.1% |
Stage
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.7 KiB |
| Closed Won | |
|---|---|
| Closed Lost | |
| Proposal | 35 |
| Negotiation | 18 |
| Qualification | 11 |
| Value | Count | Frequency (%) | |
| Closed Won | 9533 | 56.3% | |
| Closed Lost | 7350 | 43.4% | |
| Proposal | 35 | 0.2% | |
| Negotiation | 18 | 0.1% | |
| Qualification | 11 | 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 10.43258394 |
| Min length | 8 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.4 KiB |
| Prod_Category_A_None |
|---|
| Value | Count | Frequency (%) | |
| Prod_Category_A_None | 16947 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 20 |
|---|---|
| Median length | 20 |
| Mean length | 20 |
| Min length | 20 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| ID | Region | Territory | Pricing, Delivery_Terms_Quote_Appr | Pricing, Delivery_Terms_Approved | Bureaucratic_Code_0_Approval | Bureaucratic_Code_0_Approved | Submitted_for_Approval | Bureaucratic_Code | Account_Created_Date | Source | Billing_Country | Account_Name | Opportunity_Name | Opportunity_ID | Sales_Contract_No | Account_Owner | Opportunity_Owner | Account_Type | Opportunity_Type | Quote_Type | Delivery_Terms | Opportunity_Created_Date | Brand | Product_Type | Size | Product_Category_B | Price | Currency | Last_Activity | Quote_Expiry_Date | Last_Modified_Date | Last_Modified_By | Product_Family | Product_Name | ASP_Currency | ASP | ASP_(converted)_Currency | ASP_(converted) | Planned_Delivery_Start_Date | Planned_Delivery_End_Date | Month | Delivery_Quarter | Delivery_Year | Actual_Delivery_Date | TRF | Total_Amount_Currency | Total_Amount | Total_Taxable_Amount_Currency | Total_Taxable_Amount | Stage | Prod_Category_A | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 27761 | EMEA | None | 1 | 1 | 1 | 1 | 0 | Bureaucratic_Code_4 | 2015-06-16 | None | Netherlands | Account_Name_619 | Opportunity_Name_12598 | 0 | nan | Person_Name_51 | Person_Name_18 | Account_Type_2 | Opportunity_Type_1 | Non Binding | Delivery_Terms_2 | 2015-12-07 | None | None | None | None | None | None | NaT | 2016-01-30 | 2016-06-13 | Person_Name_18 | Product_Family_77 | Product_Name_99 | EUR | 0.52 | USD | 0.59 | 2016-05-01 | 2016-06-30 | 2016 - 5 | Q2 | 2016 | NaT | 10 | EUR | 5,272,800.00 | EUR | 5,272,800.00 | Closed Lost | Prod_Category_A_None |
| 1 | 27760 | EMEA | None | 0 | 0 | 0 | 0 | 0 | Bureaucratic_Code_4 | 2015-06-16 | None | Netherlands | Account_Name_619 | Opportunity_Name_12600 | 1 | 39.00 | Person_Name_51 | Person_Name_20 | Account_Type_2 | Opportunity_Type_1 | Non Binding | Delivery_Terms_2 | 2015-12-07 | None | None | None | None | None | None | NaT | 2016-01-20 | 2016-01-15 | Person_Name_20 | Product_Family_77 | Product_Name_100 | EUR | 0.53 | USD | 0.60 | 2016-01-18 | 2016-01-20 | 2016 - 1 | Q1 | 2016 | NaT | 0 | EUR | 48,230.00 | EUR | 48,230.00 | Closed Won | Prod_Category_A_None |
| 2 | 27446 | Americas | NW America | 0 | 0 | 0 | 0 | 0 | Bureaucratic_Code_4 | 2015-04-21 | Source_7 | United States | Account_Name_1794 | Opportunity_Name_469 | 2 | 760.00 | Person_Name_64 | Person_Name_8 | Account_Type_5 | Opportunity_Type_1 | Non Binding | Delivery_Terms_4 | 2015-12-08 | None | None | None | None | None | None | NaT | 2016-09-30 | 2016-09-29 | Person_Name_8 | Product_Family_81 | Product_Name_91 | USD | 0.48 | USD | 0.48 | 2016-01-25 | 2016-01-25 | 2016 - 1 | Q1 | 2016 | NaT | 0 | USD | 83,865.60 | USD | 83,865.60 | Closed Won | Prod_Category_A_None |
| 3 | 16808 | Americas | NW America | 1 | 0 | 1 | 0 | 0 | Bureaucratic_Code_5 | 2013-07-27 | Source_11 | United States | Account_Name_1201 | Opportunity_Name_415 | 3 | nan | Person_Name_8 | Person_Name_8 | Account_Type_5 | Opportunity_Type_19 | Non Binding | Delivery_Terms_1 | 2015-12-08 | Other | Product_Type_0 | Size_4 | Product_Category_B_16 | 0.42 | USD | NaT | NaT | 2018-03-27 | Person_Name_8 | Product_Family_209 | Product_Name_432 | USD | 0.53 | USD | 0.53 | 2018-02-01 | 2018-03-31 | 2018 - 2 | Q1 | 2018 | NaT | 14 | USD | 7,421,881.50 | USD | 7,421,881.50 | Closed Lost | Prod_Category_A_None |
| 4 | 16805 | Americas | NW America | 1 | 0 | 1 | 0 | 0 | Bureaucratic_Code_5 | 2013-07-27 | Source_11 | United States | Account_Name_1201 | Opportunity_Name_851 | 4 | nan | Person_Name_8 | Person_Name_8 | Account_Type_5 | Opportunity_Type_19 | Non Binding | Delivery_Terms_1 | 2015-12-08 | Other | Product_Type_0 | Size_4 | Product_Category_B_16 | 0.42 | USD | NaT | 2017-06-02 | 2018-03-27 | Person_Name_8 | Product_Family_209 | Product_Name_432 | USD | 0.53 | USD | 0.53 | 2018-02-01 | 2018-02-28 | 2018 - 2 | Q1 | 2018 | NaT | 25 | USD | 13,357,192.50 | USD | 13,357,192.50 | Closed Lost | Prod_Category_A_None |
| 5 | 16802 | Americas | NW America | 1 | 0 | 1 | 0 | 0 | Bureaucratic_Code_5 | 2013-07-27 | Source_11 | United States | Account_Name_1201 | Opportunity_Name_939 | 5 | nan | Person_Name_8 | Person_Name_8 | Account_Type_5 | Opportunity_Type_19 | Non Binding | Delivery_Terms_1 | 2015-12-08 | Other | Product_Type_0 | Size_4 | Product_Category_B_16 | 0.42 | USD | NaT | 2017-06-02 | 2018-03-27 | Person_Name_8 | Product_Family_209 | Product_Name_432 | USD | 0.53 | USD | 0.53 | 2018-02-01 | 2018-03-31 | 2018 - 2 | Q1 | 2018 | NaT | 28 | USD | 14,838,277.50 | USD | 14,838,277.50 | Closed Lost | Prod_Category_A_None |
| 6 | 16799 | Americas | NW America | 1 | 0 | 1 | 0 | 0 | Bureaucratic_Code_5 | 2013-07-27 | Source_11 | United States | Account_Name_1201 | Opportunity_Name_1618 | 6 | nan | Person_Name_8 | Person_Name_8 | Account_Type_5 | Opportunity_Type_19 | Non Binding | Delivery_Terms_4 | 2015-12-08 | None | None | None | None | None | None | NaT | NaT | 2016-10-07 | Person_Name_8 | Product_Family_164 | Product_Name_308 | USD | 0.38 | USD | 0.38 | 2017-02-01 | 2017-05-01 | 2017 - 2 | Q1 | 2017 | NaT | 7 | USD | 2,659,494.60 | USD | 2,659,494.60 | Closed Lost | Prod_Category_A_None |
| 7 | 27455 | Americas | NW America | 1 | 1 | 1 | 1 | 0 | Bureaucratic_Code_4 | 2015-04-21 | Source_7 | United States | Account_Name_1794 | Opportunity_Name_8227 | 7 | nan | Person_Name_64 | Person_Name_8 | Account_Type_5 | Opportunity_Type_1 | Non Binding | Delivery_Terms_4 | 2015-12-09 | None | None | None | None | None | None | NaT | 2016-01-07 | 2015-12-09 | Person_Name_8 | Product_Family_143 | Product_Name_251 | USD | 0.48 | USD | 0.48 | 2016-01-25 | 2016-01-25 | 2016 - 1 | Q1 | 2016 | NaT | 0 | USD | 50,688.00 | USD | 50,688.00 | Closed Won | Prod_Category_A_None |
| 8 | 24353 | Japan | None | 1 | 0 | 0 | 0 | 0 | Bureaucratic_Code_5 | 2015-04-20 | None | Japan | Account_Name_1888 | Opportunity_Name_6151 | 8 | nan | Person_Name_50 | Person_Name_50 | Account_Type_2 | Opportunity_Type_7 | Non Binding | Delivery_Terms_4 | 2015-12-09 | None | None | None | None | None | None | NaT | NaT | 2016-04-05 | Person_Name_50 | Product_Family_6 | Product_Name_6 | JPY | nan | USD | nan | 2016-02-29 | 2016-02-29 | 2016 - 2 | Q1 | 2016 | NaT | 0 | JPY | 15,600.00 | JPY | 470,400.00 | Closed Lost | Prod_Category_A_None |
| 9 | 24355 | Japan | None | 1 | 0 | 0 | 0 | 0 | Bureaucratic_Code_5 | 2015-04-20 | None | Japan | Account_Name_1888 | Opportunity_Name_6151 | 8 | nan | Person_Name_50 | Person_Name_50 | Account_Type_2 | Opportunity_Type_7 | Non Binding | Delivery_Terms_4 | 2015-12-09 | None | None | None | None | None | None | NaT | NaT | 2016-04-05 | Person_Name_50 | Product_Family_4 | Product_Name_4 | JPY | nan | USD | nan | 2016-02-29 | 2016-02-29 | 2016 - 2 | Q1 | 2016 | NaT | 0 | JPY | 4,400.00 | JPY | 470,400.00 | Closed Lost | Prod_Category_A_None |
Last rows
| ID | Region | Territory | Pricing, Delivery_Terms_Quote_Appr | Pricing, Delivery_Terms_Approved | Bureaucratic_Code_0_Approval | Bureaucratic_Code_0_Approved | Submitted_for_Approval | Bureaucratic_Code | Account_Created_Date | Source | Billing_Country | Account_Name | Opportunity_Name | Opportunity_ID | Sales_Contract_No | Account_Owner | Opportunity_Owner | Account_Type | Opportunity_Type | Quote_Type | Delivery_Terms | Opportunity_Created_Date | Brand | Product_Type | Size | Product_Category_B | Price | Currency | Last_Activity | Quote_Expiry_Date | Last_Modified_Date | Last_Modified_By | Product_Family | Product_Name | ASP_Currency | ASP | ASP_(converted)_Currency | ASP_(converted) | Planned_Delivery_Start_Date | Planned_Delivery_End_Date | Month | Delivery_Quarter | Delivery_Year | Actual_Delivery_Date | TRF | Total_Amount_Currency | Total_Amount | Total_Taxable_Amount_Currency | Total_Taxable_Amount | Stage | Prod_Category_A | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16937 | 17683 | EMEA | Germany | 0 | 0 | 0 | 0 | 0 | Bureaucratic_Code_4 | 2013-07-27 | Source_9 | Germany | Account_Name_533 | Opportunity_Name_4060 | 12797 | nan | Person_Name_13 | Person_Name_13 | Account_Type_0 | Opportunity_Type_8 | Non Binding | Delivery_Terms_2 | 2015-12-04 | None | None | None | None | None | None | NaT | 2016-01-03 | 2015-12-18 | Person_Name_13 | Product_Family_77 | Product_Name_96 | EUR | 0.53 | USD | 0.60 | 2016-02-01 | 2016-02-29 | 2016 - 2 | Q1 | 2016 | NaT | 1 | EUR | 413,400.00 | EUR | 528,918.75 | Closed Won | Prod_Category_A_None |
| 16938 | 28767 | EMEA | Germany | 1 | 0 | 0 | 0 | 0 | Bureaucratic_Code_5 | 2015-12-04 | None | Germany | Account_Name_586 | Opportunity_Name_5088 | 12798 | nan | Person_Name_13 | Person_Name_13 | Account_Type_2 | Opportunity_Type_19 | Non Binding | Delivery_Terms_2 | 2015-12-04 | None | None | None | None | None | None | NaT | 2016-02-05 | 2016-10-21 | Person_Name_13 | Product_Family_85 | Product_Name_110 | EUR | 0.47 | USD | 0.53 | 2016-08-15 | 2016-09-30 | 2016 - 8 | Q3 | 2016 | NaT | 3 | EUR | 1,307,775.00 | EUR | 1,307,775.00 | Closed Lost | Prod_Category_A_None |
| 16939 | 18324 | EMEA | Norway | 1 | 1 | 0 | 0 | 0 | Bureaucratic_Code_4 | 2013-07-27 | Source_9 | Germany | Account_Name_533 | Opportunity_Name_7202 | 12799 | 224.00 | Person_Name_13 | Person_Name_13 | Account_Type_0 | Opportunity_Type_1 | Non Binding | Delivery_Terms_2 | 2015-12-04 | None | None | None | None | None | None | NaT | 2016-04-03 | 2016-04-01 | Person_Name_13 | Product_Family_77 | Product_Name_96 | EUR | 0.52 | USD | 0.58 | 2016-04-01 | 2016-04-21 | 2016 - 4 | Q2 | 2016 | NaT | 1 | EUR | 401,700.00 | EUR | 401,700.00 | Closed Won | Prod_Category_A_None |
| 16940 | 20827 | Americas | NE America | 1 | 0 | 0 | 0 | 0 | Bureaucratic_Code_5 | 2014-06-16 | None | Germany | Account_Name_404 | Opportunity_Name_11979 | 12800 | nan | Person_Name_13 | Person_Name_13 | Account_Type_5 | Opportunity_Type_19 | Non Binding | Delivery_Terms_4 | 2015-12-04 | None | None | None | None | None | None | NaT | 2016-01-15 | 2016-10-10 | Person_Name_13 | Product_Family_164 | Product_Name_307 | USD | 0.53 | USD | 0.53 | 2016-10-03 | 2016-12-30 | 2016 - 10 | Q4 | 2016 | NaT | 20 | USD | 10,751,580.00 | USD | 21,332,500.00 | Closed Lost | Prod_Category_A_None |
| 16941 | 20830 | Americas | NE America | 1 | 0 | 0 | 0 | 0 | Bureaucratic_Code_5 | 2014-06-16 | None | Germany | Account_Name_404 | Opportunity_Name_11979 | 12800 | nan | Person_Name_13 | Person_Name_13 | Account_Type_5 | Opportunity_Type_19 | Non Binding | Delivery_Terms_4 | 2015-12-04 | None | None | None | None | None | None | NaT | 2016-01-15 | 2016-10-10 | Person_Name_13 | Product_Family_158 | Product_Name_286 | USD | 0.53 | USD | 0.53 | 2016-10-03 | 2016-12-30 | 2016 - 10 | Q4 | 2016 | NaT | 20 | USD | 10,580,920.00 | USD | 21,332,500.00 | Closed Lost | Prod_Category_A_None |
| 16942 | 8781 | EMEA | Austria | 1 | 1 | 1 | 1 | 0 | Bureaucratic_Code_4 | 2016-01-15 | Source_7 | Austria | Account_Name_726 | Opportunity_Name_9245 | 12801 | 44.00 | Person_Name_13 | Person_Name_13 | Account_Type_5 | Opportunity_Type_1 | Non Binding | Delivery_Terms_2 | 2015-12-04 | None | None | None | None | None | None | NaT | NaT | 2016-01-19 | Person_Name_13 | Product_Family_85 | Product_Name_111 | EUR | 0.52 | USD | 0.59 | 2016-03-21 | 2016-03-25 | 2016 - 3 | Q1 | 2016 | NaT | 0 | EUR | 103,350.00 | EUR | 299,715.00 | Closed Won | Prod_Category_A_None |
| 16943 | 8786 | EMEA | Austria | 1 | 1 | 1 | 1 | 0 | Bureaucratic_Code_4 | 2016-01-15 | Source_7 | Austria | Account_Name_726 | Opportunity_Name_9245 | 12801 | 44.00 | Person_Name_13 | Person_Name_13 | Account_Type_5 | Opportunity_Type_1 | Non Binding | Delivery_Terms_2 | 2015-12-04 | None | None | None | None | None | None | NaT | NaT | 2016-01-19 | Person_Name_13 | Product_Family_85 | Product_Name_111 | EUR | 0.52 | USD | 0.59 | 2016-04-04 | 2016-04-08 | 2016 - 4 | Q2 | 2016 | NaT | 0 | EUR | 93,015.00 | EUR | 299,715.00 | Closed Won | Prod_Category_A_None |
| 16944 | 8792 | EMEA | Austria | 1 | 1 | 1 | 1 | 0 | Bureaucratic_Code_4 | 2016-01-15 | Source_7 | Austria | Account_Name_726 | Opportunity_Name_9245 | 12801 | 44.00 | Person_Name_13 | Person_Name_13 | Account_Type_5 | Opportunity_Type_1 | Non Binding | Delivery_Terms_2 | 2015-12-04 | None | None | None | None | None | None | NaT | NaT | 2016-01-19 | Person_Name_13 | Product_Family_85 | Product_Name_111 | EUR | 0.52 | USD | 0.59 | 2016-03-28 | 2016-03-31 | 2016 - 3 | Q1 | 2016 | NaT | 0 | EUR | 103,350.00 | EUR | 299,715.00 | Closed Won | Prod_Category_A_None |
| 16945 | 28561 | Americas | NE America | 1 | 1 | 1 | 1 | 0 | Bureaucratic_Code_4 | 2015-10-20 | None | United States | Account_Name_944 | Opportunity_Name_5843 | 12802 | nan | Person_Name_3 | Person_Name_3 | Account_Type_5 | Opportunity_Type_1 | Non Binding | Delivery_Terms_4 | 2015-12-05 | None | None | None | None | None | None | NaT | 2016-02-29 | 2016-01-22 | Person_Name_3 | Product_Family_158 | Product_Name_287 | USD | 0.64 | USD | 0.64 | 2016-04-25 | 2016-04-29 | 2016 - 4 | Q2 | 2016 | NaT | 4 | USD | 2,346,796.88 | USD | 0.00 | Closed Lost | Prod_Category_A_None |
| 16946 | 28318 | Americas | NE America | 1 | 1 | 1 | 1 | 0 | Bureaucratic_Code_4 | 2015-09-03 | None | United States | Account_Name_1401 | Opportunity_Name_9911 | 12803 | nan | Person_Name_3 | Person_Name_3 | Account_Type_5 | Opportunity_Type_19 | Non Binding | Delivery_Terms_4 | 2015-12-05 | None | None | None | None | None | None | NaT | 2016-01-06 | 2016-09-28 | Person_Name_3 | Product_Family_164 | Product_Name_307 | USD | 0.64 | USD | 0.64 | 2016-07-01 | 2016-08-31 | 2016 - 7 | Q3 | 2016 | NaT | 40 | USD | 25,603,200.00 | USD | 0.00 | Closed Lost | Prod_Category_A_None |